"; // echo ""; if (array_key_exists('submit', $_POST)) { //define variables $subj = trim($_POST['subject']); $acyear = trim($_POST['acyear']); $schterm = trim($_POST['acterm']); $classid = trim($_POST['classid']); // $high = trim($_POST['high']); // $low = trim($_POST['low']); // $caverage = trim($_POST['average']); // mysql_select_db("$database", $conn); $res = mysql_query("SELECT subject_id , subjectname FROM subjects where subjectname = '$subj' "); $row1 = mysql_fetch_assoc($res) ; $resultid = $row1['subject_id'] ; $fp = fopen($_FILES["images"]["tmp_name"], "r"); while ($line = fgets($fp)) { // Loop through each line list ($regno ,$first, $exam) = explode("\t", $line, 3); // Split the line by the tab delimiter and store it in our list $sql = "insert into marks (stregno,acad_session,term,subject_id,stclass,firsttest,exam) values ('$regno' , '$acyear','$schterm', '$resultid', '$classid', '$first', '$exam' )" ; // Generate our sql string $result = mysql_query($sql) or die(mysql_error()); } if (isset($result)) $message = 'Result Uploaded Succesfully' ; } ?>

Result Control Panel
	Academic Session	Select Academic Year 2013/2014 2014/2015	Academic Term	Select Academic Term FIRST TERM SECOND TERM THIRD TERM CUMULATIVE ENTRANCE
	Select Subject	Select Subject to Upload ".$row['subjectname'].""; } ?>	Select Class	SELECT CLASS ID JSS 1 JSS 1A JSS 1B JSS 1C JSS 1D JSS 1E JSS 1F JSS 1G JSS 2 JSS 2A JSS 2B JSS 2C JSS 2D JSS 2E JSS 2F JSS 3 JSS 3A JSS 3B JSS 3C JSS 3D JSS 3E JSS 3F SS 1 SS 1A SS 1B SS 1C SS 1D SS 1E SS 1F SS 2 Science SS 2 Art SS 2 SS 2A SS 2B SS 2C SS 2D SS 2E SS 2F SS 3 Science SS 3 Art SS 3 SS 3A SS 3B SS 3C SS 3D SS 3E SS 3F
		Select Data File
Click here to Logout